DECLARE
V_COUNT       NUMBER;
V_SQL VARCHAR2(4000);
BEGIN
<#list BasicDataOracle as basicData>
    BEGIN
    <#if basicData.getOracleSQL()??>
        V_SQL :='${basicData.getOracleSQL()}';
    </#if>
    EXECUTE IMMEDIATE V_SQL;
    DBMS_OUTPUT.PUT_LINE('${basicData.name} 字典数据新建成功');
    exception when  others then
    dbms_output.put_line('错误号：'||sqlcode);
    dbms_output.put_line('错误信息：'||sqlerrm);
    END;
</#list>

END;